{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lists","README"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lists","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["ACTIVE HMP PATIENTS","REG999"]
["ACTIVE PATIENTS","REG000"]
["Applied","REG001"]
["Permanent","REG002"]
["Temporary Resident < 16 days","REG003"]
["Temporary Resident 16 days to 3 months","REG004"]
["Transferred Out","REG005"]
["Immediately Necessary Treatment","REG006"]
["Emergency Treatment","REG007"]
["Child Health Surveillance","REG008"]
["Contraception","REG009"]
["Maternity","REG010"]
["Minor Surgery","REG011"]
["Private","REG012"]
["Referred","REG013"]
["Walk in Centre","REG014"]
["GP with Special Interest","REG015"]
["Minor Injury Clinic","REG016"]
["HMP Inmate","REG017"]
["Visitor (EC111)","REG018"]
["INCLUDE ALL","NONE"]

{"sheet":"README","index":1,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[3,1,3,2],[11,1,11,6],[37,1,41,5],[1,7,1,10]]}
[]
[null,"Diabetic Monitoring for HMP Services",null,null,null,null,null,"Search Criteria = Last one of the below:"]
[null,null,null,null,null,null,null,"Description","Time","Entity","Codes"]
[null,"Enter Date Range",null,null,"Active Patients = Applied and Permanent",null,null,"Earliest Diagnosis","Ever","All Clinical, Problems","C10..%, C109J00, C109K00, C10C.%, C10D.%, C10E%  (Excluding C10F8%), C10F%, C10G%, C10H%, C10M%, C10N%, C10P%, C10Q.%, PKyP.%"]
[null,"FROM","BEFORE",null,"Registration Status",null,null,"Latest Diagnosis","Ever","All Clinical, Problems","C10..%, C109J00, C109K00, C10C.%, C10D.%, C10E%  (Excluding C10F8%), C10F%, C10G%, C10H%, C10M%, C10N%, C10P%, C10Q.%, PKyP.%"]
[null,"2019-07-01","2019-07-31",null,"ACTIVE HMP PATIENTS",null,null,"Resolved","Ever","All Clinical, Problems","21263%, 212H.%"]
[null,null,null,null,null,null,null,"Register End Date","Ever","All Clinical","C10..%, C109J00, C109K00, C10C.%, C10D.%, C10E%  (Excluding C10F8%), C10F%, C10G%, C10H%, C10M%, C10N%, C10P%, C10Q.%, PKyP.%"]
[null,null,null,null,null,null,null,"Outstanding Recall","Ever","Recall","66A..%, 66A2.%, 66AS.%, 9OL2.%, 9OL4.%, 9OL5.%, 9OL6.%, 9OL7.%, 9OL8.%, 9OLA.%, 9N1Q.%"]
[null,null,null,null,null,null,null,"Review","Ever","Diabetes Annual Check"]
[null,null,null,null,null,null,null,"Ethnicity","Ever","All Clinical","9S%, 9i%, 9T%, 9t%"]
[null,"1.  Enter a date range (by default this is set 1y back from today)",null,null,null,null,null,"BMI","Range","Weight"]
[null,"2.  Click the compile button to start the automatic data extraction from Vision",null,null,null,null,null,"BP","Range","BP"]
[null,"     Once the data has been compiled…",null,null,null,null,null,"HBA1C","Range","All Tests ","42W5.%"]
[null,"3.  Blue header columns are using the date range set above",null,null,null,null,null,"HBA1C Max Meds","Range","All Clinical","8BL2.%"]
[null,"4.  All other columns are either earliest or latest one as shown in the search criteria",null,null,null,null,null,"Creatinine","Range","All Tests ","44J3%, 44JC.%, 44JD.%, 44JF.%"]
[null,null,null,null,null,null,null,"Albumin","Range","All Tests ","44J6.%, 44J7.%, 44lD.%, 467A.%, 46N4.%, 46N5.%, 46N6.%, 44JG.%, 46TC.%, 46TD.%"]
[null,"To import groups of patients back into Vision, use the \"Patient Group Import App\"",null,null,null,null,null,"Earliest Proteinuria","Ever","All Clinical","1Z17.%, 1Z19.%, 1Z1B.%, 1Z1D.%, 1Z1F.%, 1Z1H.%, 1Z1K.%, C10EK%, C10EL%, C10FL%, C10FM%, K190X%, Kyu5G%, R110.%, R1100%, R1103%, R110z%, K08yA%"]
[null,"Instructions may be found via this link: ",null,null,null,null,null,"Cholesterol","Range","All Tests ","44P..%, 44PH.%, 44OE.%, 44PJ.%, 44PK.% (inc exception: 41M..%)"]
[null,null,null,null,null,null,null,"Chol Max Meds","Range","All Clinical","8BL1.%"]
[null,"This Excel workbook will minimise while the data is being compiled.",null,null,null,null,null,"Retinal Screening","Ever","All Clinical, All Tests","58C1.%, 3129.%, 312F.%, 9N2f.%, 31283%, 68A7.%, 68A8.%"]
[null,"Please be patient as this may take a few minutes to compile depending on your practice list size.",null,null,null,null,null,"Foot Care Left","Range","All Clinical","2G5I, 2G5J, 2G5K, 2G5L, 2G5d (Inc exceptions: 2G43, 2G45, 2G47, 8I6G, 8I3W, 8IAo, 8IB6)"]
[null,"Once complete it will be maximised and display a confirmation message box.",null,null,null,null,null,"Foot Care Right","Range","All Clinical","2G5E, 2G5F, 2G5G, 2G5H, 2G5e (Inc exceptions: 2G42, 2G44, 2G46, 8I6G, 8I3W, 8IAo, 8IB6)"]
[null,null,null,null,null,null,null,"Feet Left","Range","All Clinical","24F1.%, 24F6.%, 24F7.%, 24F8.%, 24F9.%, 24FA.%, 24FB.%, 24FC.%, 24FD.%, 24FE.%, 24FF.%, 29BA.%, 29BC.%, 29BD.%, 29BF.%, 29BH.%, 29BK.%, 29BN.%, 29BQ.%, 29BS.%, 29BV.%, 29H6.%, 29H7.%, 29H8.%, 29HB.%, 2G5B.%, 585V.%, 585X.%, 585b.%, 585d.% "]
[null,"NOTE:",null,null,null,null,null,"Feet Right","Range","All Clinical","24E1.%, 24E6.%, 24E7.%, 24E8.%, 24E9.%, 24EA.%, 24EB.%, 24EC.%, 24ED.%, 24EE.%, 24EF.%, 29B9.%, 29BB.%, 29BE.%, 29BG.%, 29BJ.%, 29BL.%, 29BM.%, 29BP.%, 29BR.%, 29BT.%, 29H4.%, 29H5.%, 29H9.%, 29HA.%, 2G5A.%, 585W.%, 585Y.%, 585c.%, 585e.%"]
[null,"This will only work if Vision is on DLM485 or above.",null,null,null,null,null,"Foot Examination","Range","All Clinical","29B1.%, 29B2.%, 29B20%,  29B21%,  29B3.%, 29B7.%, 29B8.%, 29H1.%, 29H2.%, 29H3.%, 311A.%, 585a.%, 66AE.%, 66AW.%, 66Ab.%, 66Ac.%, 66Aq.%, 8H7r.%, 9NND.% "]
[null,"Excel 2010 - Please \"Enable Content\" if a security Warning is displayed",null,null,null,null,null,"Smoking","Range","Smoking"]
[null,null,null,null,null,null,null,"Health Ed Advice","Ever","All Clinical","66Af.%, 679L.%, 679L0%, 661M4%, 661N4%"]
[null,"Excel 2007 - Click the Options button and ENABLE both Macros and Data Connection",null,null,null,null,null,"Refer to Heath Ed","Ever","All Clinical, Problems, Referrals","8Hj0.%, 8Hj3.%, 8Hj4.%, 8Hj5.%, (inc exceptions:  9OLM.%, 9NST.%, 8IE9.%, 8IEa.%, 8I94.%)"]
[null,"Excel 2003 - Not tested or approved for use with this version of Excel",null,null,null,null,null,"Attended Health Ed","Ever","All Clinical","9OLB.%, 9OLE.%, 9OLF.%, 9OLG.%, 9OLH.%, 9OLJ.%, 9OLK.%, 9OLL.%"]
[null,null,null,null,null,null,null,"FLU","Ever","Imms","FLU%"]
[null,"Current Version:",2.5,null,null,null,null,"ACE Issue","Range","Therapy","bi%, bA%, bk6%"]
[null,"Last updated:","2019-08-23",null,null,null,null,"ACE Allergy","Ever","Allergy","ZV14D%, U60C4%, 14LM%, TJC77%, TJC78%, TJC79%"]
[null,"Written by:","Bradley Sieve",null,null,null,null,"A2 Issue","Range","Therapy","bk3%, bk4%, bk5%, bk7%, bk8%, bk9%, bkB%, bkC%, bkD%, bkJ%, bkI%, bkJ%"]
[null,"Email:",null,null,null,null,null,"A2 Allergy","Ever","Allergy","ZV14E%, U60CB%, 14LN%"]
[null,"Website:",null,null,null,null,null,"Statin Issue","Range","Therapy","bxi%, bxg%, bxe%, bxk%, bxd%"]
[null,null,null,null,null,null,null,"Statin Allergy","Ever","Allergy","U60CA%, TJC24%, TJC25%"]
[null,"Disclaimer",null,null,null,null,null,"Earliest Future Appt","Ever","Appointments",">= today"]
[null,"In using this Microsoft Excel report you hereby acknowledge that the software cannot be guaranteed error free and may also be subject to how data is being recorded by your practice, and further acknowledge that the existence of any such errors shall not make Vision or TailorMade Info Tech Solutions Ltd responsible for any actions you carry out based on these results.",null,null,null,null,null,"IHD Diagnosis","Ever","All Clinical, Problems","G3%, Gyu3% (excluding G30A%, G310%, G331%, G332%, G341%, G36%, G37%, Gyu31%)"]
[null,null,null,null,null,null,null,"LD Diagnosis","Ever","All Clinical, Problems","E3%, Eu7%, Eu814%, Eu815%, Eu816%, Eu817%, Eu818%, Eu81z%, 918e%"]
[null,null,null,null,null,null,null,"Insulin Issue","Range","Therapy","060101"]
[null,null,null,null,null,null,null,"Sulphonylurea Issue",null,"Therapy","06010201"]
[null,null,null,null,null,null,null,"Diabetic Exception","Last 1y","All Clinical, Problems","9h41, 9h42"]
[null,"v2.4 now includes 9N1Q in the recall & eGFR result",null,null,null,null,null,"CKD Stage 4/5","Last","All Clinical, Problems","Searches last 1Z1% or K05% - Only includes 1Z13, 1Z14, 1Z1H, 1Z1J, 1Z1K, 1Z1L, 1Z1a - 1Z1f, K054, K055"]
[null,"v2.3 (66A2.00)Read code added to Diabetic recall",null,null,null,null,null,"eGFR","Range","All Tests ","415E%, 415F%, 415G%, 415K%, 415M%, 415N%"]
[null,"v2.2 now includes latest CKD diagnosis if stage 4 or 5 and diabetic QOF exception code"]
[null,"v2.1 now includes therpay issues of Insulins and Sulphonylurea"]
[null,"v2.0 Null values are now accepted in all test results"]